﻿CREATE TABLE [dbo].[Tickets] (
    [TicketId]     INT             IDENTITY (1, 1) NOT NULL,
    [FlightSeatId] INT             NOT NULL,
    [BookingId]    INT             NOT NULL,
    [FlightId]     INT             NOT NULL,
    [PassengerId]  INT             NOT NULL,
    [TicketFare]   DECIMAL (18, 2) NOT NULL
);

